
































  
  


  

  
  	
  

  

	
	

	
	
	
	
	




  
















	
	
	
	
	
	
	
	
	
	
  
  


	


	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	




    
  






  
    
  




	
	
	
	
	



<!--NewPage-->
<HTML>

<!-- Mirrored from delerium:8503/cfcdoc/content.cfm?file=C%3A%5CInetpub%5Cwwwroot%5Ctransfer%2Droot%5Ctransfer%5Ccom%5Csql%5CSQLManager%2Ecfc by HTTrack Website Copier/3.x [XR&CO'2006], Sat, 07 Apr 2007 03:17:36 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8"><!-- /Added by HTTrack -->
<HEAD>

<!-- Generated by CFDoc on 07-Apr-2007 01:17 PM -->

<LINK REL ="stylesheet" TYPE="text/css" HREF="stylesheet.css" TITLE="Style">
</HEAD>
<BODY>


	



<HR>
<!-- ======== START OF CLASS DATA ======== -->

<div style="float:left;">

<a href="default.html" style="float: right;">Documentation home page</a>
</div>
<H2>
<span style="font-size: smaller">
<a href="components3650.html" target="components">transfer.com.sql</a>
</span>
<BR>
Component SQLManager</H2>


<PRE>
<B>transfer.com.sql.SQLManager</B>
</PRE>


<HR>
Top level configuration manager for SQL objects


<HR>

<P>


<!-- ========== PROPERTY SUMMARY =========== -->

<A NAME="property_summary"><!-- --></A>






<!-- ========== METHOD SUMMARY =========== -->




<A NAME="method_summary"><!-- --></A>

<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">

<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=2><FONT SIZE="+2">
<B>Method Summary</B></FONT></TD>
</TR>











	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	



	<TR BGCOLOR="eeeeff" CLASS="TableRowColorConstructor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="content2795.html" target="_self">SQLManager</a></CODE></TD>
	<TD><CODE><B><A HREF="#init()">init</A></B>(<a href="content2efb.html">Datasource</a> datasource,&nbsp;<a href="content9a87.html">XMLFileReader</a> configReader,&nbsp;<a href="content7dd0.html">ObjectManager</a> objectManager,&nbsp;<a href="content13c8.html">Utility</a> utility)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Constructor
	</TD>
	</TR>
	

	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#create()">create</A></B>(<a href="content3bbf.html">TransferObject</a> transfer,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> useTransaction)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inserts the transfer into the DB
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#delete()">delete</A></B>(<a href="content3bbf.html">TransferObject</a> transfer,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> useTransaction)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Deletes a transfer object
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#getInsertRefreshQuery()">getInsertRefreshQuery</A></B>(<a href="content3bbf.html">TransferObject</a> transfer)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the refresh query for an insert
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="content029c.html" target="_self">Nullable</a></CODE></TD>
	<TD><CODE><B><A HREF="#getNullable()">getNullable</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#getObjectQuery()">getObjectQuery</A></B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="nativetypes.html#detail_string">string</a> key)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates and runs the query for the TransferObject
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="contentfea8.html" target="_self">QueryManager</a></CODE></TD>
	<TD><CODE><B><A HREF="#getQueryManager()">getQueryManager</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content2323.html" target="_self">RefreshSelecter</a></CODE></TD>
	<TD><CODE><B><A HREF="#getRefreshSelecter()">getRefreshSelecter</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content43c2.html" target="_self">TransferDeleter</a></CODE></TD>
	<TD><CODE><B><A HREF="#getTransferDeleter()">getTransferDeleter</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content503d.html" target="_self">TransferGateway</a></CODE></TD>
	<TD><CODE><B><A HREF="#getTransferGateway()">getTransferGateway</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content9f5b.html" target="_self">TransferInserter</a></CODE></TD>
	<TD><CODE><B><A HREF="#getTransferInserter()">getTransferInserter</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="contentdfb7.html" target="_self">TransferUpdater</a></CODE></TD>
	<TD><CODE><B><A HREF="#getTransferUpdater()">getTransferUpdater</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#getUpdateRefreshQuery()">getUpdateRefreshQuery</A></B>(<a href="content3bbf.html">TransferObject</a> transfer)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the refresh query for an insert
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_boolean" target="_self">boolean</a></CODE></TD>
	<TD><CODE><B><A HREF="#hasInsertRefresh()">hasInsertRefresh</A></B>(<a href="content3bbf.html">TransferObject</a> transfer)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Check to see if it requires a run of the refresh query
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_boolean" target="_self">boolean</a></CODE></TD>
	<TD><CODE><B><A HREF="#hasUpdateRefresh()">hasUpdateRefresh</A></B>(<a href="content3bbf.html">TransferObject</a> transfer)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Check to see if it requires a run of the refresh query
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#list()">list</A></B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lists a series of object values
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#listByProperty()">listByProperty</A></B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_string">string</a> propertyName,&nbsp;<a href="nativetypes.html#detail_any">any</a> propertyValue,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lists a series of values, filtered by a given value
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#listByPropertyMap()">listByPropertyMap</A></B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_struct">struct</a> propertyMap,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lists values, filtered by a Struct of Property : Value properties
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_query" target="_self">query</a></CODE></TD>
	<TD><CODE><B><A HREF="#listByWhere()">listByWhere</A></B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_any">any</a> whereSQL,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lists a series of values, filtered by a given value
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setNullable()">setNullable</A></B>(<a href="content029c.html">Nullable</a> Nullable)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setQueryManager()">setQueryManager</A></B>(<a href="contentfea8.html">QueryManager</a> QueryManager)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setRefreshSelecter()">setRefreshSelecter</A></B>(<a href="content2323.html">RefreshSelecter</a> RefreshSelecter)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setTransferDeleter()">setTransferDeleter</A></B>(<a href="content43c2.html">TransferDeleter</a> TransferDeleter)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setTransferGateway()">setTransferGateway</A></B>(<a href="content503d.html">TransferGateway</a> TransferGateway)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setTransferInserter()">setTransferInserter</A></B>(<a href="content9f5b.html">TransferInserter</a> TransferInserter)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setTransferUpdater()">setTransferUpdater</A></B>(<a href="contentdfb7.html">TransferUpdater</a> TransferUpdater)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#update()">update</A></B>(<a href="content3bbf.html">TransferObject</a> transfer,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> useTransaction)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Updates the Transfer in the DB
	
	
	</TD>
	</TR>
	
</TABLE>



&nbsp;
<P>



<!-- ============ METHOD DETAIL ========== -->


<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Method Detail</B></FONT></TD>
</TR>
</TABLE>












<A NAME="create()"><!-- --></A><H3>
create</H3>

<PRE>
public <A HREF="nativetypes.html#detail_void" title="">void</A> <B>create</B>(<a href="content3bbf.html">TransferObject</a> transfer,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> useTransaction)</PRE>
<DL>
  <DD>
  	
  	
		Inserts the transfer into the DB
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content3bbf.html">TransferObject</a> transfer</code> - The transfer object to insert</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> useTransaction</code> - Whether or not to use an internal transaction block</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="delete()"><!-- --></A><H3>
delete</H3>

<PRE>
public <A HREF="nativetypes.html#detail_void" title="">void</A> <B>delete</B>(<a href="content3bbf.html">TransferObject</a> transfer,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> useTransaction)</PRE>
<DL>
  <DD>
  	
  	
		Deletes a transfer object
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content3bbf.html">TransferObject</a> transfer</code> - The transfer object to insert</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> useTransaction</code> - Whether or not to use an internal transaction block</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getInsertRefreshQuery()"><!-- --></A><H3>
getInsertRefreshQuery</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>getInsertRefreshQuery</B>(<a href="content3bbf.html">TransferObject</a> transfer)</PRE>
<DL>
  <DD>
  	
  	
		Returns the refresh query for an insert
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content3bbf.html">TransferObject</a> transfer</code> - The object to refresh</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getNullable()"><!-- --></A><H3>
getNullable</H3>

<PRE>
public <A HREF="content029c.html" title="">transfer.com.sql.Nullable</A> <B>getNullable</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getObjectQuery()"><!-- --></A><H3>
getObjectQuery</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>getObjectQuery</B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="nativetypes.html#detail_string">string</a> key)</PRE>
<DL>
  <DD>
  	
  	
		Creates and runs the query for the TransferObject
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The Object BO</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> key</code> - The id key for the data</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getQueryManager()"><!-- --></A><H3>
getQueryManager</H3>

<PRE>
private <A HREF="contentfea8.html" title="">transfer.com.sql.QueryManager</A> <B>getQueryManager</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getRefreshSelecter()"><!-- --></A><H3>
getRefreshSelecter</H3>

<PRE>
private <A HREF="content2323.html" title="">RefreshSelecter</A> <B>getRefreshSelecter</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getTransferDeleter()"><!-- --></A><H3>
getTransferDeleter</H3>

<PRE>
private <A HREF="content43c2.html" title="">transfer.com.sql.TransferDeleter</A> <B>getTransferDeleter</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getTransferGateway()"><!-- --></A><H3>
getTransferGateway</H3>

<PRE>
private <A HREF="content503d.html" title="">transfer.com.sql.TransferGateway</A> <B>getTransferGateway</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getTransferInserter()"><!-- --></A><H3>
getTransferInserter</H3>

<PRE>
private <A HREF="content9f5b.html" title="">transfer.com.sql.TransferInserter</A> <B>getTransferInserter</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getTransferUpdater()"><!-- --></A><H3>
getTransferUpdater</H3>

<PRE>
private <A HREF="contentdfb7.html" title="">transfer.com.sql.TransferUpdater</A> <B>getTransferUpdater</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getUpdateRefreshQuery()"><!-- --></A><H3>
getUpdateRefreshQuery</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>getUpdateRefreshQuery</B>(<a href="content3bbf.html">TransferObject</a> transfer)</PRE>
<DL>
  <DD>
  	
  	
		Returns the refresh query for an insert
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content3bbf.html">TransferObject</a> transfer</code> - The object to refresh</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="hasInsertRefresh()"><!-- --></A><H3>
hasInsertRefresh</H3>

<PRE>
public <A HREF="nativetypes.html#detail_boolean" title="">boolean</A> <B>hasInsertRefresh</B>(<a href="content3bbf.html">TransferObject</a> transfer)</PRE>
<DL>
  <DD>
  	
  	
		Check to see if it requires a run of the refresh query
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content3bbf.html">TransferObject</a> transfer</code> - The object to refresh</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="hasUpdateRefresh()"><!-- --></A><H3>
hasUpdateRefresh</H3>

<PRE>
public <A HREF="nativetypes.html#detail_boolean" title="">boolean</A> <B>hasUpdateRefresh</B>(<a href="content3bbf.html">TransferObject</a> transfer)</PRE>
<DL>
  <DD>
  	
  	
		Check to see if it requires a run of the refresh query
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content3bbf.html">TransferObject</a> transfer</code> - The object to refresh</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="init()"><!-- --></A><H3>
init</H3>

<PRE>
public <A HREF="content2795.html" title="">SQLManager</A> <B>init</B>(<a href="content2efb.html">Datasource</a> datasource,&nbsp;<a href="content9a87.html">XMLFileReader</a> configReader,&nbsp;<a href="content7dd0.html">ObjectManager</a> objectManager,&nbsp;<a href="content13c8.html">Utility</a> utility)</PRE>
<DL>
  <DD>
  	
  	
		Constructor
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content2efb.html">Datasource</a> datasource</code> - The datasource bean</DD>
			
			  <DD><code><a href="content9a87.html">XMLFileReader</a> configReader</code> - XML reader for the config file</DD>
			
			  <DD><code><a href="content7dd0.html">ObjectManager</a> objectManager</code> - The object manager to query</DD>
			
			  <DD><code><a href="content13c8.html">Utility</a> utility</code> - The utility object</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="list()"><!-- --></A><H3>
list</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>list</B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</PRE>
<DL>
  <DD>
  	
  	
		Lists a series of object values
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> className</code> - The class of the objects to list</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> orderProperty=""]</code> - The property to order by</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"]</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"]</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="listByProperty()"><!-- --></A><H3>
listByProperty</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>listByProperty</B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_string">string</a> propertyName,&nbsp;<a href="nativetypes.html#detail_any">any</a> propertyValue,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</PRE>
<DL>
  <DD>
  	
  	
		Lists a series of values, filtered by a given value
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> className</code> - The class of the objects to list</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> propertyName</code> - The name of the property to filter by</DD>
			
			  <DD><code><a href="nativetypes.html#detail_any">any</a> propertyValue</code> - The value to filter by (only simple values)</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey</code> - boolean to whether or not to only retrieve the primary key</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> orderProperty=""]</code> - The property to order by</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"]</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"]</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="listByPropertyMap()"><!-- --></A><H3>
listByPropertyMap</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>listByPropertyMap</B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_struct">struct</a> propertyMap,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</PRE>
<DL>
  <DD>
  	
  	
		Lists values, filtered by a Struct of Property : Value properties
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> className</code> - The class of the objects to list</DD>
			
			  <DD><code><a href="nativetypes.html#detail_struct">struct</a> propertyMap</code> - Struct with keys that match to properties, and values to filter by</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey</code> - boolean to whether or not to only retrieve the primary key</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> orderProperty=""]</code> - The property to order by</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"]</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"]</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="listByWhere()"><!-- --></A><H3>
listByWhere</H3>

<PRE>
public <A HREF="nativetypes.html#detail_query" title="">query</A> <B>listByWhere</B>(<a href="nativetypes.html#detail_string">string</a> className,&nbsp;<a href="nativetypes.html#detail_any">any</a> whereSQL,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey,&nbsp;[<a href="nativetypes.html#detail_string">string</a> orderProperty=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"])</PRE>
<DL>
  <DD>
  	
  	
		Lists a series of values, filtered by a given value
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> className</code> - The class of the objects to list</DD>
			
			  <DD><code><a href="nativetypes.html#detail_any">any</a> whereSQL</code> - The where statement for the SQL Query (Do not include the 'where'). Properties can be defined as {propertyName}</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> onlyRetrievePrimaryKey</code> - boolean to whether or not to only retrieve the primary key</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> orderProperty=""]</code> - The property to order by</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> orderASC="true"]</code> - Boolean whether to order by ASC, otherwise order by DESC</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> useAliases="true"]</code> - Boolean as to whether or not to alias columns with the transfer property names</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setNullable()"><!-- --></A><H3>
setNullable</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setNullable</B>(<a href="content029c.html">Nullable</a> Nullable)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content029c.html">Nullable</a> Nullable</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setQueryManager()"><!-- --></A><H3>
setQueryManager</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setQueryManager</B>(<a href="contentfea8.html">QueryManager</a> QueryManager)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="contentfea8.html">QueryManager</a> QueryManager</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setRefreshSelecter()"><!-- --></A><H3>
setRefreshSelecter</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setRefreshSelecter</B>(<a href="content2323.html">RefreshSelecter</a> RefreshSelecter)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content2323.html">RefreshSelecter</a> RefreshSelecter</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setTransferDeleter()"><!-- --></A><H3>
setTransferDeleter</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setTransferDeleter</B>(<a href="content43c2.html">TransferDeleter</a> TransferDeleter)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content43c2.html">TransferDeleter</a> TransferDeleter</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setTransferGateway()"><!-- --></A><H3>
setTransferGateway</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setTransferGateway</B>(<a href="content503d.html">TransferGateway</a> TransferGateway)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content503d.html">TransferGateway</a> TransferGateway</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setTransferInserter()"><!-- --></A><H3>
setTransferInserter</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setTransferInserter</B>(<a href="content9f5b.html">TransferInserter</a> TransferInserter)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content9f5b.html">TransferInserter</a> TransferInserter</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setTransferUpdater()"><!-- --></A><H3>
setTransferUpdater</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setTransferUpdater</B>(<a href="contentdfb7.html">TransferUpdater</a> TransferUpdater)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="contentdfb7.html">TransferUpdater</a> TransferUpdater</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="update()"><!-- --></A><H3>
update</H3>

<PRE>
public <A HREF="nativetypes.html#detail_void" title="">void</A> <B>update</B>(<a href="content3bbf.html">TransferObject</a> transfer,&nbsp;<a href="nativetypes.html#detail_boolean">boolean</a> useTransaction)</PRE>
<DL>
  <DD>
  	
  	
		Updates the Transfer in the DB
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content3bbf.html">TransferObject</a> transfer</code> - The transferObject to update</DD>
			
			  <DD><code><a href="nativetypes.html#detail_boolean">boolean</a> useTransaction</code> - Whether or not to use an internal transaction block</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>







</BODY>

<!-- Mirrored from delerium:8503/cfcdoc/content.cfm?file=C%3A%5CInetpub%5Cwwwroot%5Ctransfer%2Droot%5Ctransfer%5Ccom%5Csql%5CSQLManager%2Ecfc by HTTrack Website Copier/3.x [XR&CO'2006], Sat, 07 Apr 2007 03:17:36 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8"><!-- /Added by HTTrack -->
</HTML>